package com.whut.mapper;

import com.whut.v_model.*;
import com.whut.v_vo.comperInsReportBaseVO.ProblemFirstListVO;
import com.whut.v_vo.equipReportBaseVO.CheckSuggestionVO;
import com.whut.v_vo.equipReportBaseVO.EquipExistProblemDesVO;
import com.whut.v_vo.newHiddenReportGLList;
import com.whut.v_vo.oldSysExamInfoVO;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface NewProblemCollectDetailMapper {
    
    int insert(ProblemCollectDetail record);

    int insertSelective(ProblemCollectDetail record);

    List<ProblemCollectDetail> selectZLInfoById(int checkId);

    List<ProblemCollectDetail> selectAQInfoById(int checkId);

    List<ProblemCollectDetail> selectGLInfoById(int checkId);

    List<ProblemCollectDetail> getAllProblemCollectInfoByCheckId(int checkId);

    List<Object> getAllName1(int checkId);

    List<ProblemCollectDetail> getFourthPoint(int checkId, String pName1, int secondId);

    List<ProblemCollectDetail> getZJFourthPoint(int checkId,int thirdId);

    List<ProblemCollectDetail> getZJSixthPoint(int checkId,int thirdId);

    int countName4(int fourthId, int checkId);

    int getAllNum(int checkId);

    List<Object> getAllName4(int checkId);

    List<Object> getAllName4ByName1(int checkId, String pName1);

    List<ProblemCollectDetail> getAllName6InfoByName4(int checkId, int fourthId, String pName1);

    List<ProblemCollectDetail> getsixthPoints(int checkId, int fourthId);

    List<ProblemCollectDetail> getZJsixthPoints(int checkId,int fourthId);

    float getdeductSum(int checkId, int sixthId);

    List<Object> getSecondId(int checkId, String pName1);

    List<Object> getThirdId(int checkId, String pName1, int secondId);


    float getAllExtraPoint(int checkId);

    String getMaxRiskLever(int checkId, String pName1);

    String getOverAllLever(int checkId);

    List<Object> getAllName1Id(int checkId);

    List<Object> getFourthId(int checkId, String pName1, int secondId, int thirdId);

    List<ProblemCollectDetail> getAllFourthInfo(int checkId, int fourthId);

    List<ProblemCollectDetail> getAllInfoByName1(int checkId, String pName1);

    List<Object> getFourthCountList(int checkId, int thirdId);

    ProblemCollectDetail getPCDBymkey(int mkey);

    int getRiskPointCount(int checkId, int fourthId, String riskPoint);

    int getAllRiskPointCountByType(int checkId, String riskPoint);

    List<Integer> getAllFirstIdByProjectInfoList(List<Integer> list);

    List<Integer> getAllSecondIdByProjectInfoList(int firstId, List<Integer> list);

    List<Integer> getAllThirdIdByProjectInfoList(int secondId, List<Integer> list);

    List<Integer> getAllFourthIdByProjectInfoList(int thirdId, List<Integer> list);

    List<Integer> getAllFifthIdByProjectInfoList(int fourthId, List<Integer> list);

    List<Integer> getAllSixthIdByProjectInfoList(int fifthId, List<Integer> list);

    List<Integer> getAllNextIdByFather(List<Integer> list,int number,String preNum);

    List<Integer> getAllTaskIdByCheckItemsAndCheckId(List<Integer> list,int checkItemsId,String name);

    int  getProblemNum(List<Integer>list,int taskId,int checkItemsId,String name);

    ProblemNumSearch1 getProblemSearch1Info(List<Integer>list, int taskId, int checkItemsId, String name);

    int getAllProblemNumForStatistic(List<Integer> list,int number,String preNum);

    List<Object> getAllName1IdForType3Report(int checkId,List<String> list);

    List<Object> getAllName4ByName1ForType3(int checkId,String pName1,List<String> list);

    List<ProblemCollectDetail> getAllName6InfoByName4ForType3(int checkId,int fourthId,String pName1,List<String> list);

    int getProblemNumByFourthId(int checkId,int fourthId);

    int getProblemNumOver3(int checkId,int fourthId,List<String>list);

    List<Integer> getAllZJthirdId(int checkId,int secondId);

    int getProblemNumByThirdId(int checkId,int thirdId);

    int getRiskPointNumOver3ByThirdId(int checkId,int thirdId,List<String> list);

    int getRiskPointNumOver3ByFourthId(int checkId,int fourthId,List<String> list);

    
    
    List<UnitProblemNum> UnitProblemNumStatistic(List<Integer> checkIdList, List<Object> unitNameList, String unitType, String idType, String prenumName, String pNameNum, int preNum);

    List<ProblemCollectDetail> getAllInfoByFirstId(int checkId,int firstId);

    List<ProblemCollectDetail> selectAllInfoByThirdId(int checkId,int thirdId);

    int getZJGLProblemNumByThirdId(int checkId,int thirdId);

    int getZJGLProblemNumBySixthId(int checkId,int sixthId);

    List<Integer> getAllThirdIdByFirstId(int checkId,int firstId);

    List<Object> getAllName4ByThirdId(int checkId,int thirdId);

    
    List<UnitRiskPoint> UnitRiskPointStatistic(List<Integer> checkIdList, List<Object> unitNameList, String unitType);

    List<Integer> getAllFourthIdByCheckList(List<Integer> list,int firstId);

    TimesStat getAllSecurityRiskPoint(List<Integer> list, int firstId);

    int getAllSecurityProblemNum(List<Integer> list,int firstId);

    int getSecurityProblemNum(List<Integer> list,int fourthId);

    List<Integer> getSecurityPart3ProjectNum(List<Integer> list,int fourthId);

    TimesStat getSecurityRiskPoint(List<Integer> list,int fourthId);

    List<Integer> getSecurityInnerSixthId(List<Integer> list,int fourthId);

    int getPart3InnerProblemNum(List<Integer> list,int sixthId);

    List<Integer> getPart3InnerProject(List<Integer> list,int sixthId);

    
    List<ProblemCollectDetail> getForthLevelByCheckId(int checkId);

    
    List<ProblemCollectDetail> getProDescByCheckIdAndpName4(int checkId, String pName4);

    
    List<ProblemCollectDetail> getPart3InnerDescriptionAllInfo(List<Integer> list,int sixthId);

    
    List<ProblemCollectDetail> getSgList(int checkId);

    
    List<ProblemCollectDetail> getJlList(int checkId);

    List<ProblemCollectDetail> getProDescByCheckIdAndpName4UnderSecur(int checkId, String pName4);

    List<Integer> getAllFourthId(int checkId);

    int getProblemNumByRiskPoint(int checkId,int fourthId,String riskPoint);

    List<String> allRiskPointListNotTiXing(int checkId,int fourthId);

    List<Integer> getAllFourthIdByNum(int checkId,int number);

    
    List<ProblemCollectDetail> getPCDByCheckId(int checkId);


    List<ProblemCollectDetail> getAllThirdInfoMXTQ(int checkId);
    List<ProblemCollectDetail> getAllFourthInfoMXTQ(int checkId,int thirdId);
    List<ProblemCollectDetail> getAllCheckFourthInfoMXTQ(int checkId);

    List<Integer> getAllFourthIdByCheckIdAndFirstId(int checkId,int firstId);
    List<ProblemCollectDetail> getRiskWarning(Integer contractId);
    List<ProblemCollectDetail> getProblemByProject(Integer checkId,Integer projectId);
    List<RiskWarning> getProblemByCheckandFirstId(List<Integer> list,Integer firstId);
    List<RiskWarning> getProblemByCheckandSecondId(List<Integer> list,Integer secondId);
    List<RiskWarning> getProblemByCheckandThirdId(List<Integer> list,Integer thirdId);
    List<RiskWarning> getProblemByCheckandFourthId(List<Integer> list,Integer fourthId);
    List<RiskWarning> getProblemByCheckandFifthId(List<Integer> list,Integer fifthId);
    List<RiskWarning> getProblemByCheckandSixthId(List<Integer> list,Integer sixthId);
    List<RiskWarning> getProblemsByContractandUnit(List<Integer> contractlist, List<String> jslist, List<String> jllist, List<String> sglist);

    int getAllGLFourthCount(int checkId);

    List<Object> getAllItemsBySecondName(String secondName, List<Integer> list);

    List<ProblemCollectDetail> getProblemDetail(int projectId, String reserve1);

    List<ProblemCollectDetail> getProblemsByTaskId(int taskId);

    List<ProblemCollectDetail> getNoProblemItem(int checkId, int secondId);

    int countFourthProblem(int checkId, int secondId, String name4);

    int countProblemBySecondId(int checkId, int secondId);

    List<ProblemCollectDetail> getEquipProblems(String eqipNum, int checkId, int fourthId);

    List<ProblemCollectDetail> requestThirdListAll(int checkId);

    List<ProblemCollectDetail> getProblemDescriptionBySixthId(int checkId, int sixthId);

    List<EquipExistProblemDesVO> getEquipExistProblemDesList(int checkId, int projectId);

    List<CheckSuggestionVO> getCheckSuggestionList(int checkId, int projectId);

    
    List<ProblemFirstListVO> getProblemFirstList(int checkId, int projectId);

    List<Integer> getAllFourthIdByCheckIdAndThirdId(int checkId, int thirdId);

    List<Integer> getAllSixthIdBycheckIdAndFourthId(int checkId, int sixId);

    List<oldSysExamInfoVO> getOldSysFourthInfo(Integer checkId, Integer fourthId);


    List<newHiddenReportGLList> getAllGLInfoByCheckId(int checkId);

    
    List<ProblemCollectDetail> getAllInfoByCheck(@Param("check")String check);

    
    List<ProblemCollectDetail> getAllInfoByCheckThirdId(@Param("list1")List list1,@Param("check")String check);

    
    int getProblemNumByCheckIdEquipNumRiskPoint(@Param("checkid")int checkId,@Param("equipnum")String equipNum,@Param("riskpoint")String riskPoint);
}